﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_ALERTS_TASKS_CATEGORIES_IN')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_ALERTS_TASKS_CATEGORIES_IN
	END

GO

CREATE Procedure dbo.PRC_TB_ALERTS_TASKS_CATEGORIES_IN
	(
		@TATC_ALERT_TASK_ID int,
		@TATC_CATEGORY_ID int
	)

AS

insert into TB_ALERTS_TASKS_CATEGORIES
(TATC_ALERT_TASK_ID,
TATC_CATEGORY_ID)
values
(@TATC_ALERT_TASK_ID,
@TATC_CATEGORY_ID)

GO

GRANT EXEC ON dbo.PRC_TB_ALERTS_TASKS_CATEGORIES_IN TO PUBLIC

GO

